{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Disclaimer","Appr_Surf_Quantities","Appr_Surf_Calc"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":27,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Disclaimer","index":0,"n_rows":22,"n_cols":11,"rows_kept":22,"cut":false,"hidden":false,"merged":[[9,3,10,8],[11,3,25,8],[21,10,25,14]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Disclaimer"]
[]
[null,null,null,"This Design Calculation Spreadsheet is provided \"as-is\" without warranty of any kind. The Montana Department of Transportation makes no representations or warranties whatsoever with respect to the accuracy or completeness of this tool and assumes no responsibility for the suitability of this tool for a particular purpose; and MDT will not be liable for any damages incurred as a result of errors in this tool. \n\nBy selecting Accept, you are agreeing to these terms and conditions."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"WARNING: \nFor the tool to work properly, please make sure you click on \"Enable Content/Macros\" if the security warning appears."]

{"sheet":"Appr_Surf_Quantities","index":1,"n_rows":71,"n_cols":13,"rows_kept":71,"cut":false,"hidden":true,"merged":[[16,1,20,3],[47,1,51,3]]}
[]
[null,"Input Values"]
[null,"PM Unit Weight",4167,"lb/yd3 (Project Specific)"]
[null,"PM Depth",0.2,"ft"]
[null,"CAC Depth",0.6,"ft"]
[null,"Emul. Asph. Tack",0.05,"gal/yd2 (RDM App. J, pg 9)"]
[null,"Bituminous Material",8.5,"lb/gal (RDM App. J, pg 9)"]
[null,"Seal",0.42,"gal/yd2 (RDM App. J, pg 9)"]
[]
[null,"* Measured Quantities from \"Approach Surfacing.dgn\""]
[null,"* Measured Quantities (24' wide top)"]
[null,null,"12.0'","25.0'","ADDL. FT."]
[null,"PM Surface Area",525.63819999999998,868.25229999999999,24]
[null,"Top CAC Surface Area",594.10540000000003,975.12929999999994,26.8]
[null,"Bot CAC Surface Area",757.13139999999999,1252.7047,35]
[]
[null,"**View \"Approach Surfacing.dgn\" for area measurements. Used average end area for PM and CAC.\n \n**Assumes a 24' wide approach with a 25' radius. Modify ApproachSurfacing.dgn for other conditions."]
[]
[]
[]
[]
[]
[null,"PL. MIX BIT. SURF.",null,null,null,null,"CR. AGG. COURSE",null,null,null,"COVER"]
[]
[null,"Approach Length","Area","Volume","Weight",null,"Approach Length","Area","Volume",null,"Approach Length","Area","Area"]
[null,"ft","ft2","yd3","tons",null,"ft","ft2","yd3",null,"ft","ft2","yd2"]
[null,12,{"$f":"(C13+C14)/2","v":559.87180000000001},{"$f":"(C27*$C$4)/27","v":4.1471985185185183},{"$f":"ROUND(D27*$C$3/2000,1)","v":8.6},null,25,{"$f":"(D15+D14)/2","v":1113.9169999999999},{"$f":"ROUND(H27*$C$5/27,1)","v":24.8},null,25,{"$f":"D13","v":868.25229999999999},{"$f":"ROUND(L27/9,0)","v":96}]
[null,25,{"$f":"(D13+D14)/2","v":921.69079999999997},{"$f":"(C28*$C$4)/27","v":6.8273392592592597},{"$f":"ROUND(D28*$C$3/2000,1)","v":14.2},null,"ADDL. FT.",{"$f":"(E14+E15)/2","v":30.9},{"$f":"ROUND(H28*$C$5/27,1)","v":0.7},null,"ADDL. FT.",{"$f":"E13","v":24},{"$f":"ROUND(L28/9,0)","v":3}]
[null,"ADDL. FT.",{"$f":"(E13+E14)/2","v":25.4},{"$f":"(C29*$C$4)/27","v":0.18814814814814815},0.4]
[]
[]
[]
[]
[null,"EMUL. ASPH. TACK",null,null,null,null,"AGG. TREAT.",null,null,null,"SEAL"]
[]
[null,"Approach Length","Asph. Tack Area","Asph. Tack Gal.",null,null,"Approach Length","Agg. Treat. Area","Agg. Treat. Area",null,"Approach Length","Area","Seal Tons"]
[null,"ft","yd2","gals",null,null,"ft","ft2","yd2",null,"ft","yd2","tons"]
[null,12,{"$f":"I38","v":66},{"$f":"ROUND(C38*$C$6,1)","v":3.3},null,null,12,{"$f":"C14","v":594.10540000000003},{"$f":"ROUND(H38/9,0)","v":66},null,25,{"$f":"M27","v":96},{"$f":"ROUND(L38*$C$8*$C$7*1/2000,2)","v":0.17}]
[null,25,{"$f":"I39","v":108},{"$f":"ROUND(C39*$C$6,1)","v":5.4},null,null,25,{"$f":"D14","v":975.12929999999994},{"$f":"ROUND(H39/9,0)","v":108},null,"ADDL. FT.",{"$f":"M28","v":3},{"$f":"ROUND(L39*$C$8*$C$7*1/2000,2)","v":0.01}]
[null,"ADDL. FT.",{"$f":"I40","v":3},{"$f":"ROUND(C40*$C$6,1)","v":0.2},null,null,"ADDL. FT.",{"$f":"E14","v":26.8},3]
[]
[null,"* Measured Quantities (30' wide top)"]
[null,null,"12.0'","25.0'","ADDL. FT."]
[null,"PM Surface Area",597.63819999999998,1018.2523,30]
[null,"Top CAC Surface Area",666.10540000000003,1125.1293000000001,32.799999999999997]
[null,"Bot CAC Surface Area",829.13139999999999,1402.7047,41]
[]
[null,"**View Approach Surfacing.dgn for area measurements. Used average end area for PM and CAC.\n \n**Assumes a 30' wide approach with a 25' radius. Modify ApproachSurfacing.dgn for other conditions."]
[]
[]
[]
[]
[]
[null,"PL. MIX BIT. SURF.",null,null,null,null,"CR. AGG. COURSE",null,null,null,"COVER"]
[]
[null,"Approach Length","Area","Volume","Weight",null,"Approach Length","Area","Volume",null,"Approach Length","Area","Area"]
[null,"ft","ft2","yd3","tons",null,"ft","ft2","yd3",null,"ft","ft2","yd2"]
[null,12,{"$f":"(C44+C45)/2","v":631.87180000000001},{"$f":"(C58*$C$4)/27","v":4.6805318518518524},{"$f":"ROUND(D58*$C$3/2000,1)","v":9.8000000000000007},null,25,{"$f":"(D46+D45)/2","v":1263.9169999999999},{"$f":"ROUND(H58*$C$5/27,1)","v":28.1},null,25,{"$f":"D44","v":1018.2523},{"$f":"ROUND(L58/9,0)","v":113}]
[null,25,{"$f":"(D44+D45)/2","v":1071.6908000000001},{"$f":"(C59*$C$4)/27","v":7.9384503703703713},{"$f":"ROUND(D59*$C$3/2000,1)","v":16.5},null,"ADDL. FT.",{"$f":"(E14+E15)/2","v":30.9},{"$f":"ROUND(H59*$C$5/27,1)","v":0.7},null,"ADDL. FT.",{"$f":"E13","v":24},{"$f":"ROUND(L59/9,0)","v":3}]
[null,"ADDL. FT.",{"$f":"(E44+E45)/2","v":31.4},{"$f":"(C60*$C$4)/27","v":0.2325925925925926},0.5]
[]
[]
[]
[]
[null,"EMUL. ASPH. TACK",null,null,null,null,"AGG. TREAT.",null,null,null,"SEAL"]
[]
[null,"Approach Length","Asph. Tack Area","Asph. Tack Gal.",null,null,"Approach Length","Agg. Treat. Area","Agg. Treat. Area",null,"Approach Length","Area","Seal Tons"]
[null,"ft","yd2","gals",null,null,"ft","ft2","yd2",null,"ft","yd2","tons"]
[null,12,{"$f":"I69","v":74},{"$f":"ROUND(C69*$C$6,1)","v":3.7},null,null,12,{"$f":"C45","v":666.10540000000003},{"$f":"ROUND(H69/9,0)","v":74},null,25,{"$f":"M58","v":113},{"$f":"ROUND(L69*$C$8*$C$7*1/2000,2)","v":0.2}]
[null,25,{"$f":"I70","v":125},{"$f":"ROUND(C70*$C$6,1)","v":6.3},null,null,25,{"$f":"D45","v":1125.1293000000001},{"$f":"ROUND(H70/9,0)","v":125},null,"ADDL. FT.",{"$f":"M59","v":3},{"$f":"ROUND(L70*$C$8*$C$7*1/2000,2)","v":0.01}]
[null,"ADDL. FT.",{"$f":"I71","v":4},{"$f":"ROUND(C71*$C$6,1)","v":0.2},null,null,"ADDL. FT.",{"$f":"E45","v":32.799999999999997},4]

{"sheet":"Appr_Surf_Calc","index":2,"n_rows":130,"n_cols":27,"rows_kept":130,"cut":false,"hidden":true,"merged":[[44,3,44,6],[44,17,44,19],[44,14,44,16],[45,14,45,16],[46,14,48,14],[46,15,48,15],[46,16,48,16],[45,17,45,19],[46,17,48,17],[46,18,48,18],[46,19,48,19],[46,9,48,9],[46,10,48,10],[45,5,48,5],[45,6,48,6],[45,3,48,3],[45,4,48,4],[43,1,43,26],[44,1,48,1],[44,2,48,2],[44,7,48,7],[44,8,44,10],[44,26,48,26],[44,23,44,25],[46,8,48,8],[45,11,45,13],[45,23,45,25],[46,23,48,23],[46,24,48,24],[46,25,48,25],[44,20,44,22],[45,20,45,22],[45,8,45,10],[46,20,48,20],[46,21,48,21],[46,22,48,22],[44,11,44,13],[46,11,48,11],[46,12,48,12],[46,13,48,13]]}
[]
[null,null,null,null,null,null,null,"INPUTS"]
[null,null,null,null,null,null,null,"Mainline Roadway Width to Shld.",{"$f":"12+4","v":16},"linear ft"]
[null,null,null,null,null,null,null,"Radius & 1ST ft quantities",25,"linear ft"]
[null,null,null,null,null,null,null,"PM Unit Weight Appr_Surf_Quantities",{"$f":"Appr_Surf_Quantities!C3","v":4167},"lb/yd3"]
[null,null,null,null,null,null,null,"PM Unit Weight Project",4167,"lb/yd3"]
[]
[null,null,null,null,null,null,null,"PL. MIX. BIT SURF."]
[null,null,null,null,null,null,null,"OVERLAY PROJECTS - 3.0' PM STRIP",{"$f":"ROUND(2.3*I6/I5,1)","v":2.2999999999999998},"tons"]
[null,null,null,null,null,null,null,"1ST 25' W/ 12' PL. MIX STRIP",{"$f":"ROUND(Appr_Surf_Quantities!E27*(I6/I5),1)","v":8.6},"tons"]
[null,null,null,null,null,null,null,"1ST 25' PL. MIX SURFACED",{"$f":"ROUND(Appr_Surf_Quantities!E28*(I6/I5),1)","v":14.2},"tons"]
[null,null,null,null,null,null,null,"EACH ADDITIONAL FOOT PL. MIX",{"$f":"ROUND(Appr_Surf_Quantities!E29*(I6/I5),1)","v":0.4},"tons"]
[]
[null,null,null,null,null,null,null,"CR. AGG. COURSE"]
[null,null,null,null,null,null,null,"1ST 25' CR. AGG. COURSE",{"$f":"ROUND(Appr_Surf_Quantities!I27*(I6/I5),1)","v":24.8},"yd3"]
[null,null,null,null,null,null,null,"EACH ADDITIONAL FOOT CR. AGG. COURSE",{"$f":"ROUND(Appr_Surf_Quantities!I28*(I6/I5),1)","v":0.7},"yd3"]
[]
[null,null,null,null,null,null,null,"EMUL. ASPH. TACK"]
[null,null,null,null,null,null,null,"1ST 25' W/ 12' PL. MIX STRIP",{"$f":"ROUND(Appr_Surf_Quantities!D38*(I6/I5),1)","v":3.3},"gals"]
[null,null,null,null,null,null,null,"1ST 25' PL. MIX SURFACED",{"$f":"ROUND(Appr_Surf_Quantities!D39*(I6/I5),1)","v":5.4},"gals"]
[null,null,null,null,null,null,null,"EACH ADDITIONAL FOOT EMUL. ASPH. TACK",{"$f":"ROUND(Appr_Surf_Quantities!D40*(I6/I5),1)","v":0.2},"gals"]
[]
[null,null,null,null,null,null,null,"AGG. TREAT."]
[null,null,null,null,null,null,null,"1ST 25' W/ 12' PL. MIX STRIP",{"$f":"Appr_Surf_Quantities!I38","v":66},"yd2"]
[null,null,null,null,null,null,null,"1ST 25' PL. MIX SURFACED",{"$f":"Appr_Surf_Quantities!I39","v":108},"yd2"]
[null,null,null,null,null,null,null,"EACH ADDITIONAL FOOT AGG. TREAT.",{"$f":"Appr_Surf_Quantities!I40","v":3},"yd2"]
[]
[null,null,null,null,null,null,null,"COVER"]
[null,null,null,null,null,null,null,"1ST 25'",{"$f":"Appr_Surf_Quantities!M27","v":96},"yd2"]
[null,null,null,null,null,null,null,"EACH ADDITIONAL FOOT COVER",{"$f":"Appr_Surf_Quantities!M28","v":3},"yd2"]
[]
[null,null,null,null,null,null,null,"SEAL"]
[null,null,null,null,null,null,null,"1ST 25'",{"$f":"Appr_Surf_Quantities!M38","v":0.17},"tons"]
[null,null,null,null,null,null,null,"EACH ADDITIONAL FOOT SEAL",{"$f":"Appr_Surf_Quantities!M39","v":0.01},"tons"]
[]
[null,null,null,null,null,null,null,"NOTE: All quantities are based on the typical 24' approach with a 25' radius. Only adjustment is for the different plant mix unit weight."]
[null,"SPREADSHEET SETUP:"]
[null,"   *FARM FIELD APPR. GET PAVED FIRST 12', GRAVEL TO ROW (typically, unless we get a permit and extend the approach past row)"]
[null,"   **PRIVATE APPR. GET PAVED TO ROW, GRAVEL TO END"]
[null,"   ***PUBLIC APPR. GET PAVED TO END"]
[]
[null,">> ALL QUANTITES ASSUME 24' TOP WIDTH; INPUT PLANT MIX UNIT WEIGHT IN 'Appr_Surf_Quantities' TAB"]
[]
[null,"APPROACHES (INCLUDED IN ADDITIONAL SURFACING FRAME)"]
[null,"STATION","TYPE","linear feet",null,null,null,"PROPOSED SURFACE","tons",null,null,"cubic yards",null,null,"gals",null,null,"square yards",null,null,"square yards",null,null,"tons",null,null,"REMARKS"]
[null,null,null,"LENGTH,\nC.L. TO R/W","LENGTH,\nPAST R/W","LENGTH,\nMAINLINE","LENGTH,\nAPPROACH",null,"PLANT MIX BIT. SURF.",null,null,"CRUSHED AGG. COURSE",null,null,"EMULSIFIED ASPHALT TACK",null,null,"AGG. TREAT.",null,null,"COVER",null,null,"SEAL"]
[null,null,null,null,null,null,null,null,"1ST 25'","ADDL.","TOTAL","1ST 25'","ADDL.","TOTAL","1ST 25'","ADDL.","TOTAL","1ST 25'","ADDL.","TOTAL","1ST 25'","ADDL.","TOTAL","1ST 25'","ADDL.","TOTAL"]
[]
[]
[null,null,null,null,null,null,{"$f":"IF(D50=\"\",\"\",SUM(D50:E50)-F50)","v":""},null,{"$f":"IF(C50=\"\",\"\",IF(C50=\"FARM FIELD\",$I$10,IF(OR(C50=\"PRIVATE\",C50=\"PUBLIC\"),$I$11,\"FALSE\")))","v":""},{"$f":"IF(C50=\"\",\"\",IF(C50=\"FARM FIELD\",0,IF(AND(G50>=$I$4,C50=\"PRIVATE\"),((D50-F50)-$I$4)*$I$12,IF(AND(G50>=$I$4,C50=\"PUBLIC\"),(G50-$I$4)*$I$12,\"FALSE\"))))","v":""},{"$f":"IF(C50=\"\",\"\",ROUND(SUM(I50:J50),0))","v":""},{"$f":"IF(C50=\"\",\"\",IF(G50>=$I$4,$I$15,\"FALSE\"))","v":""},{"$f":"IF(C50=\"\",\"\",IF(G50>=$I$4,(G50-$I$4)*$I$16,\"FALSE\"))","v":""},{"$f":"IF(F50=\"\",\"\",ROUND(SUM(L50:M50),0))","v":""},{"$f":"IF(C50=\"\",\"\",IF(C50=\"FARM FIELD\",$I$19,IF(OR(C50=\"PRIVATE\",C50=\"PUBLIC\"),$I$20,\"FALSE\")))","v":""},{"$f":"IF(C50=\"\",\"\",IF(C50=\"FARM FIELD\",0,IF(AND(G50>=$I$4,C50=\"PRIVATE\"),((D50-F50)-$I$4)*$I$21,IF(AND(G50>=$I$4,C50=\"PUBLIC\"),(G50-$I$4)*$I$21,\"FALSE\"))))","v":""},{"$f":"IF(I50=\"\",\"\",ROUND(SUM(O50:P50),0))","v":""},{"$f":"IF(C50=\"\",\"\",IF(C50=\"FARM FIELD\",$I$24,IF(OR(C50=\"PRIVATE\",C50=\"PUBLIC\"),$I$25,\"FALSE\")))","v":""},{"$f":"IF(C50=\"\",\"\",IF(C50=\"FARM FIELD\",0,IF(AND(G50>=$I$4,C50=\"PRIVATE\"),((D50-F50)-$I$4)*$I$26,IF(AND(G50>=$I$4,C50=\"PUBLIC\"),(G50-$I$4)*$I$26,\"FALSE\"))))","v":""},{"$f":"IF(L50=\"\",\"\",ROUND(SUM(R50:S50),0))","v":""},{"$f":"IF(OR(C50=\"\",C50=\"FARM FIELD\",C50=\"PRIVATE\"),\"\",IF(C50=\"PUBLIC\",$I$29,\"FALSE\"))","v":""},{"$f":"IF(OR(C50=\"\",C50=\"FARM FIELD\",C50=\"PRIVATE\"),\"\",IF(AND(C50=\"PUBLIC\",G50>=$I$4),(G50-$I$4)*$I$30,\"FALSE\"))","v":""},{"$f":"IF(SUM(U50:V50)=0,\"\",ROUND(SUM(U50:V50),0))","v":""},{"$f":"IF(OR(C50=\"\",C50=\"FARM FIELD\",C50=\"PRIVATE\"),\"\",IF(C50=\"PUBLIC\",$I$33,\"FALSE\"))","v":""},{"$f":"IF(OR(C50=\"\",C50=\"FARM FIELD\",C50=\"PRIVATE\"),\"\",IF(AND(C50=\"PUBLIC\",G50>=$I$4),(G50-$I$4)*$I$34,\"FALSE\"))","v":""},{"$f":"IF(SUM(X50:Y50)=0,\"\",ROUND(SUM(X50:Y50),1))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(D51=\"\",\"\",SUM(D51:E51)-F51)","v":""},null,{"$f":"IF(C51=\"\",\"\",IF(C51=\"FARM FIELD\",$I$10,IF(OR(C51=\"PRIVATE\",C51=\"PUBLIC\"),$I$11,\"FALSE\")))","v":""},{"$f":"IF(C51=\"\",\"\",IF(C51=\"FARM FIELD\",0,IF(AND(G51>=$I$4,C51=\"PRIVATE\"),((D51-F51)-$I$4)*$I$12,IF(AND(G51>=$I$4,C51=\"PUBLIC\"),(G51-$I$4)*$I$12,\"FALSE\"))))","v":""},{"$f":"IF(C51=\"\",\"\",ROUND(SUM(I51:J51),0))","v":""},{"$f":"IF(C51=\"\",\"\",IF(G51>=$I$4,$I$15,\"FALSE\"))","v":""},{"$f":"IF(C51=\"\",\"\",IF(G51>=$I$4,(G51-$I$4)*$I$16,\"FALSE\"))","v":""},{"$f":"IF(F51=\"\",\"\",ROUND(SUM(L51:M51),0))","v":""},{"$f":"IF(C51=\"\",\"\",IF(C51=\"FARM FIELD\",$I$19,IF(OR(C51=\"PRIVATE\",C51=\"PUBLIC\"),$I$20,\"FALSE\")))","v":""},{"$f":"IF(C51=\"\",\"\",IF(C51=\"FARM FIELD\",0,IF(AND(G51>=$I$4,C51=\"PRIVATE\"),((D51-F51)-$I$4)*$I$21,IF(AND(G51>=$I$4,C51=\"PUBLIC\"),(G51-$I$4)*$I$21,\"FALSE\"))))","v":""},{"$f":"IF(I51=\"\",\"\",ROUND(SUM(O51:P51),0))","v":""},{"$f":"IF(C51=\"\",\"\",IF(C51=\"FARM FIELD\",$I$24,IF(OR(C51=\"PRIVATE\",C51=\"PUBLIC\"),$I$25,\"FALSE\")))","v":""},{"$f":"IF(C51=\"\",\"\",IF(C51=\"FARM FIELD\",0,IF(AND(G51>=$I$4,C51=\"PRIVATE\"),((D51-F51)-$I$4)*$I$26,IF(AND(G51>=$I$4,C51=\"PUBLIC\"),(G51-$I$4)*$I$26,\"FALSE\"))))","v":""},{"$f":"IF(L51=\"\",\"\",ROUND(SUM(R51:S51),0))","v":""},{"$f":"IF(OR(C51=\"\",C51=\"FARM FIELD\",C51=\"PRIVATE\"),\"\",IF(C51=\"PUBLIC\",$I$29,\"FALSE\"))","v":""},{"$f":"IF(OR(C51=\"\",C51=\"FARM FIELD\",C51=\"PRIVATE\"),\"\",IF(AND(C51=\"PUBLIC\",G51>=$I$4),(G51-$I$4)*$I$30,\"FALSE\"))","v":""},{"$f":"IF(SUM(U51:V51)=0,\"\",ROUND(SUM(U51:V51),0))","v":""},{"$f":"IF(OR(C51=\"\",C51=\"FARM FIELD\",C51=\"PRIVATE\"),\"\",IF(C51=\"PUBLIC\",$I$33,\"FALSE\"))","v":""},{"$f":"IF(OR(C51=\"\",C51=\"FARM FIELD\",C51=\"PRIVATE\"),\"\",IF(AND(C51=\"PUBLIC\",G51>=$I$4),(G51-$I$4)*$I$34,\"FALSE\"))","v":""},{"$f":"IF(SUM(X51:Y51)=0,\"\",ROUND(SUM(X51:Y51),1))","v":""}]
[null,null,null,null,null,null,"",null,"","","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,"",null,"","","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,"",null,"","","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,"",null,"","","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,"",null,"","","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,"",null,"","","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,"",null,"","","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,"",null,"","","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,"",null,"","","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,"",null,"","","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,"",null,"","","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,"",null,"","","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,"",null,"","","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,"",null,"","","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,"",null,"","","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,"",null,"","","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,"",null,"","","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,"",null,"","","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,"",null,"","","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,"",null,"","","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,"",null,"","","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,"",null,"","","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,"",null,"","","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,"",null,"","","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,"",null,"","","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,"",null,"","","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,"",null,"","","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,"",null,"","","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,"",null,"","","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,"",null,"","","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,"",null,"","","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,"",null,"","","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,"",null,"","","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,"",null,"","","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,"",null,"","","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,"",null,"","","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,"",null,"","","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,"",null,"","","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,"",null,"","","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,"",null,"","","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,"",null,"","","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,"",null,"","","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,"",null,"","","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,"",null,"","","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,"",null,"","","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,"",null,"","","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,"",null,"","","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,"",null,"","","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,"",null,"","","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,"",null,"","","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,"",null,"","","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,"",null,"","","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,"",null,"","","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,"",null,"","","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,"",null,"","","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,"",null,"","","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,"",null,"","","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,"",null,"","","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,"",null,"","","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,"",null,"","","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,"",null,"","","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,"",null,"","","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,"",null,"","","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,{"$f":"IF(D115=\"\",\"\",SUM(D115:E115)-F115)","v":""},null,{"$f":"IF(C115=\"\",\"\",IF(C115=\"FARM FIELD\",$I$10,IF(OR(C115=\"PRIVATE\",C115=\"PUBLIC\"),$I$11,\"FALSE\")))","v":""},{"$f":"IF(C115=\"\",\"\",IF(C115=\"FARM FIELD\",0,IF(AND(G115>=$I$4,C115=\"PRIVATE\"),((D115-F115)-$I$4)*$I$12,IF(AND(G115>=$I$4,C115=\"PUBLIC\"),(G115-$I$4)*$I$12,\"FALSE\"))))","v":""},{"$f":"IF(C115=\"\",\"\",ROUND(SUM(I115:J115),0))","v":""},{"$f":"IF(C115=\"\",\"\",IF(G115>=$I$4,$I$15,\"FALSE\"))","v":""},{"$f":"IF(C115=\"\",\"\",IF(G115>=$I$4,(G115-$I$4)*$I$16,\"FALSE\"))","v":""},{"$f":"IF(F115=\"\",\"\",ROUND(SUM(L115:M115),0))","v":""},{"$f":"IF(C115=\"\",\"\",IF(C115=\"FARM FIELD\",$I$19,IF(OR(C115=\"PRIVATE\",C115=\"PUBLIC\"),$I$20,\"FALSE\")))","v":""},{"$f":"IF(C115=\"\",\"\",IF(C115=\"FARM FIELD\",0,IF(AND(G115>=$I$4,C115=\"PRIVATE\"),((D115-F115)-$I$4)*$I$21,IF(AND(G115>=$I$4,C115=\"PUBLIC\"),(G115-$I$4)*$I$21,\"FALSE\"))))","v":""},{"$f":"IF(I115=\"\",\"\",ROUND(SUM(O115:P115),0))","v":""},{"$f":"IF(C115=\"\",\"\",IF(C115=\"FARM FIELD\",$I$24,IF(OR(C115=\"PRIVATE\",C115=\"PUBLIC\"),$I$25,\"FALSE\")))","v":""},{"$f":"IF(C115=\"\",\"\",IF(C115=\"FARM FIELD\",0,IF(AND(G115>=$I$4,C115=\"PRIVATE\"),((D115-F115)-$I$4)*$I$26,IF(AND(G115>=$I$4,C115=\"PUBLIC\"),(G115-$I$4)*$I$26,\"FALSE\"))))","v":""},{"$f":"IF(L115=\"\",\"\",ROUND(SUM(R115:S115),0))","v":""},{"$f":"IF(OR(C115=\"\",C115=\"FARM FIELD\",C115=\"PRIVATE\"),\"\",IF(C115=\"PUBLIC\",$I$29,\"FALSE\"))","v":""},{"$f":"IF(OR(C115=\"\",C115=\"FARM FIELD\",C115=\"PRIVATE\"),\"\",IF(AND(C115=\"PUBLIC\",G115>=$I$4),(G115-$I$4)*$I$30,\"FALSE\"))","v":""},{"$f":"IF(SUM(U115:V115)=0,\"\",ROUND(SUM(U115:V115),0))","v":""},{"$f":"IF(OR(C115=\"\",C115=\"FARM FIELD\",C115=\"PRIVATE\"),\"\",IF(C115=\"PUBLIC\",$I$33,\"FALSE\"))","v":""},{"$f":"IF(OR(C115=\"\",C115=\"FARM FIELD\",C115=\"PRIVATE\"),\"\",IF(AND(C115=\"PUBLIC\",G115>=$I$4),(G115-$I$4)*$I$34,\"FALSE\"))","v":""},{"$f":"IF(SUM(X115:Y115)=0,\"\",ROUND(SUM(X115:Y115),1))","v":""}]
[null,null,null,null,null,null,"",null,"","","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,"",null,"","","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,"",null,"","","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,"",null,"","","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,"",null,"","","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,"",null,"","","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,"",null,"","","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,"",null,"","","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,"",null,"","","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,"",null,"","","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,"",null,"","","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,"",null,"","","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,"",null,"","","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,"",null,"","","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,{"$f":"IF(D130=\"\",\"\",SUM(D130:E130)-F130)","v":""},null,"","","","","","","","","","","","","","","","","",""]